2016-12-12 - 28512 - Service Request - Year End BI Activities for 2017 #CrystalReportsSupport
Service Request
28512 - Year End - BI Activities for 2017
Problem Summary
Need to reschedule BI reports and check for hard coded year in BI tools.
Admin Info
Purpose
|
Need to reschedule BI reports and check for hard coded year in BI tools.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
12-12-2016
|
Resolved by
|
Dhananjay G/ Venkateswara Reddy
|
Resolved Date
|
12-31-2016
|
Document Status
|
Complete
|
Detailed Problem Description
The following is the list of activities for Year End BI Activities for 2017:
1. Reschedule all reports with year 2017 for all regions.
2. Check for hard coded year value at universe level as well as query level.
3. Check for hard coded year value at analysis query level.
Solution Analysis and Recommendations
1. Need to find rescheduled reports for all regions.
2. Need to list the rescheduled reports.
3. Need to be find out archived list of reports.
4. Need to be check current year and previous year parameter values and need to change that parameter values.
5. Need to check if the failed notifications are enabled or not. In case failed notification are disabled then we need to fix that issue.
6. Need to check hard coded year value at universe level as well as query level.
7. Need to check hard coded year value at analysis query level.
8. Need to reschedule total of 123 reports.
Resolution
1. Listed the reports that need to be rescheduled for all regions.
2. Rescheduled the reports listed in previous step.
3. Did not reschedule archived list of reports.
4. Checked current year and previous year parameter values and then changed the parameter values.
5. Checked the failed notifications are enabled or not. In case failed notifications are disabled then we have enabled the failed notifications.
6. Checked for hard coded year value at universe level as well as query level and then changed hard coded year values.
7. Checked for hard coded year value at analysis query level and then changed hard coded year values.
8. In total rescheduled 123 reports in BI Production.
9. Cross checked the all the reports for consistency.
10. Please find below the list of scheduled reports:
Scheduled Reports_2017.xls
Release Information
None